SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001772s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042343 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042343 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752583,780376,969848,993520,254264,595569,483963,949845,494556,911373,970648,868984,45440,1016379,438154,789050,267571,365406,246794,27354,16454,179346,622318,234860,815136,726962,499021,830921,997455,861317,947866,19141,975781,1010097,345664,444936,44212,265942,179954,7532,1029583,273083,398931,535307,1043208,617018,542386,1044732,743507,481132,232875,100849,247215,941697,267276,926450,1027832,395344,566733,139494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]