SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004699s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418978 LIMIT 1 [ RunTime:0.002101s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418978 [ RunTime:0.004772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861777,417498,833537,584264,900991,1002952,915487,288672,1029508,239847,459849,763751,943665,676053,3154,645092,30869,215280,209091,510156,171517,666437,835876,601793,271089,110419,655105,996887,509828,726423,300976,728930,508893,851890,876511,119123,41606,677688,214782,487750,997913,1009732,1007167,843157,198314,328540,72672,488093,125227,674657,724912,397506,704758,471617,211063,959513,815878,781845,749901,419799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]