SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530030 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530030 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875482,383888,195561,459943,471139,613498,385320,102301,1047941,917611,535240,489831,952933,206672,492869,1024097,163822,94240,725661,145314,952142,655428,284608,695281,435103,49612,296918,1033285,91411,476421,750354,422130,219895,585935,224748,131719,217430,845690,482613,213540,800804,411290,1029076,420704,628589,798730,618504,408156,322203,179014,790362,394606,903047,712983,172190,683016,161025,1022667,86929,951547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]