SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003057s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261312 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261312 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87839,50505,67823,1028222,901162,366157,1028602,192772,396196,547199,807692,187407,556178,712543,876085,656584,907354,327654,85513,673797,726229,1048059,805448,999992,638880,362535,131038,62387,447185,797992,309253,297326,155959,764446,724070,238372,157549,726083,834761,410039,107709,206238,1047919,157660,96111,88980,749147,119636,425358,284784,914269,86929,306784,779619,321031,390888,207221,948114,658482,1013764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]