SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404553 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404553 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181432,80881,317340,721908,252767,360320,532230,703171,934085,47189,275140,585839,598234,164365,685122,360366,965717,763719,281914,430809,863340,611859,332647,52164,273435,457038,382735,572117,459094,753279,793128,364760,548969,423705,340434,357979,636717,944694,218958,416878,639622,507707,881007,82648,681439,284415,827475,290189,172644,163180,342343,739081,750676,592403,191583,755043,372607,713408,17198,340335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]