SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511276 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511276 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008495,756002,363492,294152,317896,474798,410892,313209,227764,833726,751244,383341,44699,643461,47327,768684,115198,569233,108761,280946,963411,677802,845718,747691,83718,688614,921697,969430,857837,639757,600871,159779,440957,546793,912798,591354,764562,449285,673991,471154,619778,355183,658573,287477,556668,853200,109051,597916,462256,956471,9564,121646,445798,197232,317507,931526,1048512,180812,388849,208192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002350s ]