SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491474 LIMIT 1 [ RunTime:0.002439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491474 [ RunTime:0.003308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556141,362477,292873,162571,1036960,790581,312844,607228,448947,66672,468808,429542,1026843,255978,644510,1021318,53275,429217,1031661,935815,335540,669896,114210,997489,237312,542035,381272,716930,656215,910214,329779,141163,1025348,751532,1017388,555309,405309,575060,496800,935590,983830,499003,357121,205170,952513,1021689,264619,765431,1028761,452362,317929,1046236,1042277,363660,882153,350177,242308,122249,1038707,584274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002949s ]