SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264352 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264352 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100023,593967,282249,809138,773756,30775,476340,500581,366529,816048,221829,413956,1046329,1046982,673055,74110,659875,82668,368630,364036,430620,714062,781917,417521,14322,173679,923859,967042,669336,672465,993640,42504,811587,630507,810305,140682,292904,101942,133910,549768,68414,181413,23539,114011,927363,781059,539087,350185,362810,826632,841856,571001,375487,1028663,487409,603779,367033,692143,704717,99145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000807s ]