SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001923s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201534 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201534 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465253,65257,395203,864907,573690,299718,417007,664857,623903,597754,701920,130389,709103,338271,979413,617073,729869,900011,287519,378716,721473,62773,353154,655306,17225,190119,845898,826792,78254,878427,318392,860593,1015545,205917,1031422,173755,913340,709977,853396,334822,212388,641037,937761,134664,420631,909196,135006,86370,156874,960154,606761,715807,537491,1028829,1043262,681191,715764,683998,434174,49193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001436s ]