SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51901 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51901 [ RunTime:0.002503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632055,115992,467303,671361,387361,4700,474520,205363,180949,921622,242720,630147,889173,51429,655482,74312,859600,610274,757216,336539,153497,328865,24380,69492,971391,2099,741985,370150,893607,189961,767224,988174,970824,410784,284707,307427,369755,540922,1013436,941630,489492,640873,161334,651612,688419,432959,360347,635228,432794,471612,593843,278461,171674,250430,292913,448329,462630,999744,691480,331500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]