SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985281 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985281 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314873,911763,754338,281610,108528,429424,288281,838473,28172,448551,285621,472676,936349,229258,224616,565143,149503,995731,816781,41850,228079,649884,408692,506512,16703,939014,787475,131243,148698,211487,773178,437030,256101,522093,324945,249470,997673,565415,866186,164072,495359,919828,341954,293549,870459,1003629,273541,39435,516628,828645,741658,112884,649383,712255,164439,207705,191315,664504,70545,978836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001591s ]