SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142380 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142380 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342533,116109,203655,360834,135922,188773,57070,63945,490449,1028955,278279,874797,360340,848777,400510,1044385,889752,396900,525599,961350,321947,335080,982695,424989,906516,282648,187438,385810,982909,174198,962377,451295,421191,1015604,767050,653317,546821,518484,711772,255822,408811,93075,129708,311716,186527,670876,614509,781594,443471,490002,432971,386564,185468,842023,428337,722741,292336,828883,861017,578746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001653s ]