SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002677s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431981 LIMIT 1 [ RunTime:0.001394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431981 [ RunTime:0.002562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464466,10122,85324,140850,946515,563918,144102,756297,181766,519266,644610,793084,250675,144161,255619,993220,346379,563100,723419,771733,821184,12683,7259,313080,13792,469112,316503,199858,498776,24457,765020,836861,230565,499280,575438,897716,721817,974512,485725,4048,218521,681398,276541,349411,199898,366765,46572,250330,456333,215983,313840,1033837,615866,256666,112835,36754,379653,769832,724737,971612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]