SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411153 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411153 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788871,17665,686662,411421,258326,754184,107078,1020018,646658,575874,708284,623328,626496,141610,349756,414876,960575,452905,1014677,1032517,109942,206113,718059,760594,385955,928195,967353,914882,82267,155053,377641,220130,880919,966336,35920,193743,40691,715683,500082,538783,484694,288293,226111,636703,450728,86391,295730,882960,1035189,208095,478024,755700,892908,516012,5893,175225,805144,1037139,370715,808115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]