SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535499 LIMIT 1 [ RunTime:0.003568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535499 [ RunTime:0.003168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623449,486038,166588,590377,917630,418665,216406,105021,768406,891105,673607,299347,787576,538903,952095,227087,512484,543543,558688,37850,426762,688624,839928,1042814,1041622,8059,954672,599463,438988,95088,78404,16566,913048,842580,902284,443245,407797,240757,1036591,103106,94719,279080,235988,565249,680430,150547,48282,963430,266777,886868,560652,40417,668611,75666,192523,667878,457062,1016581,649460,739867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]