SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024083 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024083 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885035,694759,397559,152540,300739,438058,457975,974952,560510,543562,791081,281541,699613,805477,61797,914463,14358,841236,745927,784985,931993,602564,1041358,889384,315723,903046,88285,906380,561636,672171,622621,624679,879582,517262,495691,398083,510827,319143,728771,819886,2759,720438,9494,567371,620611,972264,664670,1008241,757371,443817,57197,949836,754307,300710,241956,633159,907741,119121,668302,251949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]