SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820158 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820158 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620655,1032915,362510,942318,281204,1028587,551896,457115,582040,888173,271337,601730,163675,694424,1042096,330363,771021,945097,643030,902256,509782,793664,509846,124412,154246,812636,359302,1026313,419921,145363,163948,567466,498626,149480,673912,256903,472794,945259,732830,1020303,252453,133523,518466,757264,847518,407970,299203,202400,761265,32365,183630,396632,204460,905246,967335,693241,928578,943368,890786,813520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]