SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204442 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204442 [ RunTime:0.004660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169466,671353,129305,142378,973834,721091,61790,1015649,177743,375007,133600,741312,968595,43119,25993,1041415,1014018,789193,550220,9721,1002751,525487,419115,1036851,246903,142890,129522,399731,623830,137986,488109,1024513,35645,126773,74708,15615,815991,1041655,827626,7877,608727,253657,893776,407740,393195,157068,811601,251569,587166,74925,899647,235207,469958,992826,134973,85741,82554,451944,344293,125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002250s ]