SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501316 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501316 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20780,656876,41777,850713,995251,352717,386662,605547,210299,260315,676951,863957,617978,337017,1028714,565623,278952,753269,403083,842096,89707,45368,220652,173473,283267,187578,371261,125030,987404,834172,546256,129125,430236,561393,482775,805131,498358,405508,265288,248871,330864,351532,268886,806817,681169,543986,216556,280378,264509,556865,706299,883594,902199,372132,749251,995994,235631,155395,862077,838891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]