SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203461 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203461 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167126,1022290,683777,337796,734661,197785,937057,135878,845948,84487,276895,840611,34739,636873,917209,15657,788121,593847,1043828,192645,55640,164569,690129,255542,249046,426754,132082,273911,467960,730804,226155,834107,749701,515071,1016676,329516,681270,751689,371751,607256,761779,606143,989347,794165,173639,888436,632887,1044940,71094,111276,530623,1025027,571999,313856,503803,300180,1034469,344323,905385,535387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]