SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001722s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535826 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535826 [ RunTime:0.002742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012765,386789,830042,795881,357508,721103,16984,737398,507844,157809,873802,850315,183869,736388,458861,109976,181133,435228,156003,755353,791242,965368,127400,586311,1037885,623874,685710,420646,739489,40896,1039546,893593,980050,856683,560084,451206,64385,339836,744621,825443,513579,752016,673571,690376,1004537,564464,374592,922331,808775,509739,423592,79586,670619,429443,792573,854520,273273,590899,543034,548132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001961s ]