SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442191 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442191 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698127,775799,433626,434627,770127,376398,65059,59050,7386,928306,28794,616602,1020838,381866,490414,689685,560775,931555,676075,609035,358111,693492,406524,288040,320930,334610,859932,860667,263960,94426,572033,1011397,143680,573580,500314,500537,182203,662785,901205,303372,383670,231834,266503,489309,517132,431648,834210,798022,756864,26100,420173,382977,287219,537330,550405,890446,765528,613700,735144,692947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]