SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397694 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397694 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890131,325993,391500,889033,425632,757332,601567,407279,28018,22135,771141,361874,843819,447911,802375,19420,78172,469666,580029,740338,26943,785082,805794,992040,778941,377486,897405,245862,98185,602619,30895,1048905,90592,702314,277878,1014507,56420,798715,404480,584072,841638,140571,233673,992383,737539,784222,152646,502581,466928,188552,751902,800854,141667,719231,205369,574657,123778,80557,502180,692210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]