SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018127 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018127 [ RunTime:0.002475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368822,189959,1018139,742953,807590,512013,377548,670641,871070,928346,230266,640960,711880,443821,247604,801443,175989,629593,271761,383520,398841,346089,82923,451988,12328,363115,795934,53707,402271,344596,870356,150917,887676,395627,401018,610177,15390,959653,1026,910389,295364,151284,687156,119129,370085,342145,91621,258414,1005236,889464,888729,837130,563585,1027335,1039790,115197,31166,820372,454248,781699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018127 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018127 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]