SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540073 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540073 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569032,590348,951381,397290,457809,1027088,901511,776510,407489,710172,874435,852027,738540,509611,140835,95840,124779,540439,196053,10386,762223,700542,710748,50096,952448,492082,1048247,475356,803531,634028,706339,682531,341479,493355,90981,381202,56191,515020,228981,935776,669157,925501,1004998,978818,524378,35894,358722,965965,773462,73682,164911,654701,58259,703102,490628,616110,567970,1043302,827888,226865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001124s ]