SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507064 LIMIT 1 [ RunTime:0.001474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507064 [ RunTime:0.004477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500568,79943,385309,961751,571244,463674,941642,429521,799230,1003485,363814,74244,238703,323355,11102,525398,37383,796365,469007,444516,433657,702955,509972,705616,824148,244137,174921,605657,187644,418404,1035543,467106,882415,247431,684509,878828,49421,695571,322957,112373,778037,111771,225369,444363,608548,273021,861235,791852,266023,567399,421466,714788,1005709,683594,462297,330326,106286,713754,379265,256693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000805s ]