SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535213 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535213 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371210,434543,122300,106055,987638,1042209,926378,687061,127838,761334,55044,148098,877396,975998,929185,226518,496700,663445,293152,654562,214148,225580,145347,22383,498120,849784,116514,941132,680086,599301,815747,961774,403360,1039358,181608,921963,51101,513601,855902,750121,1048337,391420,584877,177959,453839,747292,888473,619414,596743,1024614,595448,17395,147068,188140,897702,204841,454928,201207,144736,727923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]