SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501635 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501635 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924609,1029406,83914,296355,878727,502860,120594,401731,44625,59005,570168,988586,732325,573047,724277,339914,471428,912013,770875,579908,164138,767511,40211,418474,686472,290774,922741,667108,145792,1027538,757215,907118,196662,682965,253664,724273,793620,324551,162442,980183,280915,60786,487115,145118,261983,898376,537067,808006,1037143,65330,921592,1013430,159139,464720,380227,428703,691178,822514,748497,483702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501635 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501635 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]