SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104373 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104373 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196922,542992,34295,1029911,142313,385329,395259,207397,572496,899148,74514,279437,90017,66649,1007209,607013,545491,111640,941942,77857,594022,1026445,320879,757971,859568,1028670,875210,388478,101056,529280,644809,1048447,175420,63688,728740,175412,414295,617755,68324,111515,153192,1046919,120620,284030,780607,906947,357748,322338,143719,635241,217446,791305,702236,160354,755251,937426,177777,847052,441630,359360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000983s ]