SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473751 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473751 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822875,33983,899596,817790,715261,889913,489016,466559,71508,354886,251568,291432,805016,216869,467297,648808,555082,987607,355765,814930,132861,100093,380297,960528,760386,524638,266830,626231,607599,557386,778258,182627,966530,424451,751278,144942,338812,255348,982532,297418,815920,1010445,381082,88943,277246,700687,519009,197870,513097,36975,497449,999826,2013,622017,895647,545665,519512,682076,219964,77643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]