SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201830 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201830 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263900,711895,55727,483705,371699,1022683,720448,678777,488906,818727,912295,933582,525610,246655,930164,229103,779697,808551,464320,645459,539786,862670,1000009,897347,360443,472775,958557,113411,779144,654099,734281,114534,644903,172524,76366,823060,352775,742588,750857,596974,1023563,743619,310241,30589,905896,256767,661959,117840,873320,439433,269557,540703,220325,816853,100350,926856,281792,857848,590733,880171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]