SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425045 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425045 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490280,999014,159522,751751,842300,13924,958525,189938,593560,952425,459808,864725,146941,802735,348557,400166,630704,591372,528838,964550,602905,770389,209307,475971,172762,49433,428954,107350,913662,811743,866535,91059,439997,533533,290118,852327,161228,189761,447717,781847,699526,275566,141273,98904,692723,927812,179981,464139,284451,992487,356523,462654,717829,776926,520902,826556,58705,356282,107348,24367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]