SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404471 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404471 [ RunTime:0.001472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397867,27339,892606,600637,464779,283963,739857,770534,256353,415215,500803,903663,97639,377086,223430,832332,971780,265740,565435,196920,149020,85519,792962,12015,1042158,161283,438266,139630,31069,458699,680708,467706,602985,95810,455531,619602,236717,144370,924077,773740,477351,786317,334927,963548,355729,749413,664796,350107,398366,496523,1005226,39775,620779,1009497,384932,257,943309,681849,748203,540308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]