SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014287 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014287 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682582,933942,246984,541675,364112,197111,234862,299445,399914,669275,657719,526473,948608,1027192,364432,90161,291222,250350,272453,602479,190572,190536,796807,769366,305380,245001,789125,467619,960496,81359,953483,917322,756712,836333,402697,44245,32980,923735,105059,185442,244149,837217,975961,236706,219925,435412,900398,150969,756491,441696,1027930,696903,233064,983850,221083,408151,135429,999229,56040,184744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]