SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404030 LIMIT 1 [ RunTime:0.000847s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404030 [ RunTime:0.002973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252951,536641,151300,1013856,873142,305946,443358,530308,361148,286590,909951,86590,38829,198388,431091,53444,429595,332166,705837,1031052,665229,952860,52660,872686,656340,41695,672429,326481,841904,521036,698610,782765,297647,131743,312006,480312,608429,233350,152286,692643,793905,289007,979718,323224,372641,564398,611281,793170,387631,928237,372699,32264,779869,528955,697489,1020529,638386,1003537,808164,265451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000764s ]