SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010935 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010935 [ RunTime:0.002170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339489,502948,475602,748292,67934,546117,208050,888757,786812,671351,531171,9821,571904,758850,591533,246950,339752,480577,748369,216017,874423,289494,360851,310502,237473,675157,302154,1027070,684533,959949,840101,1033110,29087,39018,537429,929288,564272,1015679,1003319,695686,524064,877571,839832,349749,1035449,674095,512376,506597,1036554,906816,855705,272546,26116,430308,315239,492014,251495,335669,896189,479046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001222s ]