SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533648 LIMIT 1 [ RunTime:0.000274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533648 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169426,733941,270504,14775,623987,1042951,407604,996995,886223,16127,616197,342076,994896,40941,37035,256800,314122,450599,504603,259925,151886,208402,72337,587671,373439,882618,345514,222360,78394,933079,274916,988994,292655,753424,745969,8101,286702,1028825,330663,715693,462947,1019181,275132,787100,338980,1031136,83754,583643,228441,992210,364767,989784,185983,828547,527545,520044,354129,969275,873820,929464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]