SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461912 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461912 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349161,211397,670314,625828,892179,910246,257749,27382,415215,41978,298748,545721,548532,691410,189394,212522,681168,27585,966563,279005,161742,334044,413072,635150,1034339,332650,474259,765337,202228,536751,997654,144484,259526,212925,29349,424900,963776,120017,709081,929194,658985,940658,1000066,430781,383042,902498,201408,558016,560863,74718,300588,672231,134944,169868,78213,974868,124453,392903,400567,852909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]