SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 902043 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 902043 [ RunTime:0.002697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922313,602785,526750,253824,189629,722821,711146,180891,983035,326113,687754,739237,334297,370206,553694,500910,332947,911849,949036,967257,210162,512495,220445,226066,373970,1045498,230255,383788,495714,502831,745284,719937,236746,53178,752416,438329,901495,995164,662549,433190,210304,818081,499898,89784,660475,860372,1010413,757675,841652,674574,501469,1023058,679019,281199,318277,447626,403600,750577,200292,442328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 902043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 902043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]