SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514611 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514611 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28211,966744,103594,451583,691818,601405,270342,270922,520218,413658,487907,88113,770695,745983,599925,982493,770094,58439,604735,415384,510665,515781,150861,145999,468689,773405,585710,145914,698340,372179,36061,139411,42175,15523,580440,370801,376051,991629,288061,1004014,310194,894926,327075,33073,656318,364639,395425,336835,231571,736084,735472,840006,495536,166186,419147,432096,689021,294855,310528,634481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002984s ]