SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327800 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327800 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168076,669913,482590,982234,103088,547354,531613,129216,48560,154182,983726,573720,751364,77336,1019214,1006708,465079,978591,255263,217317,941597,50785,807000,1020958,593904,509226,912923,984315,442847,267548,448393,503275,683538,614733,904903,469744,433961,172746,844443,434015,975195,344787,170817,1029023,428586,200888,466722,424467,884899,1031300,1023569,107327,846900,117748,276754,273124,777505,92672,722347,60810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]