SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 979041 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 979041 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734151,327289,820992,45038,477816,307234,624832,663058,691673,803066,704386,411980,875140,801095,371642,162754,1039139,206976,421635,844086,1029862,679003,739799,881169,155124,382132,652545,640687,32883,970096,145687,653094,938287,493454,59673,664734,728351,524528,255040,1038532,335320,56287,522463,1029694,57302,991096,1020271,441397,960534,910512,500042,299898,190438,682570,564237,974147,204337,338138,1033176,991471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 979041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 979041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]