SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287891 LIMIT 1 [ RunTime:0.000830s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287891 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149664,862997,205851,930072,785015,754089,783944,365195,1001463,578076,847692,328843,788997,610078,42610,177220,476588,155454,873732,702368,367366,975227,267744,694338,594688,945002,962337,43493,544387,662293,202311,456389,120591,33376,984053,585494,338436,604337,179436,24080,151770,798991,263369,459812,917654,405302,318459,665581,482930,434553,895385,343873,695762,410657,351237,736192,776261,315720,1004712,722116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001780s ]