SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010643 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010643 [ RunTime:0.002230s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696794,1006437,138880,919522,856139,429686,182520,871852,229502,840881,564553,13393,1029019,108301,718337,576038,930175,550290,890096,1040053,1041015,931055,333689,703483,838079,72881,130724,509820,1037871,822445,145230,140874,381992,342187,891038,624543,498039,518923,282255,184744,243485,552768,418132,207072,551691,178515,208298,452571,1024271,464136,475761,388859,463348,731741,34915,170072,433524,331363,555109,346284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]