SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533003 LIMIT 1 [ RunTime:0.002150s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533003 [ RunTime:0.006461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375580,923445,912698,401826,686309,765562,780249,30574,908096,904810,8588,10977,712254,812309,309925,1022811,589704,194060,989293,419025,683326,341255,577223,334543,353721,468707,7246,308505,291388,833779,363281,733637,441370,845901,564334,387300,475731,795860,386917,999315,296620,301939,254110,935810,859235,1032811,662812,262344,145784,305064,928281,960547,302731,920956,549960,82130,125274,141387,985084,283093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]