SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003654s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196948 LIMIT 1 [ RunTime:0.004441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196948 [ RunTime:0.004817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2175,382629,1028978,882497,388925,226795,279442,468862,610735,295335,755825,392616,428564,82178,490981,1042243,123046,659737,140099,1021843,835514,1041803,214237,738133,509044,980362,253008,25422,665981,544460,64700,685866,974539,902431,180113,275513,683007,1010355,48105,227762,703137,542817,572466,317464,446138,275283,157767,944523,625868,22821,45740,922328,30867,82773,334566,470193,1024224,1012622,462515,677646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001405s ]