SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419952 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419952 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703544,132162,242818,760610,13755,919276,889646,686153,570993,662933,324859,584227,10960,94538,123211,563310,521938,556082,737071,431024,23177,467110,111077,150435,526850,207903,907266,205641,84389,39054,741599,265642,63299,877793,304999,188566,649608,9132,964929,762404,134857,557616,119862,155810,464106,562535,753381,477452,9237,713792,404483,1019305,862937,318622,198634,644158,494424,208443,291758,853442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]