SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981813 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981813 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303511,351186,75300,157026,45896,337948,256080,836494,43189,933277,336892,644416,823876,716733,38027,603837,875400,374655,15305,812023,776987,886381,441665,127729,535145,199933,108517,798432,531857,548623,163931,374112,824533,763767,991795,183933,228540,267970,777871,1004062,430449,899242,288882,576906,849270,585545,980564,461307,119809,558357,625304,964316,174400,522721,988932,958891,636884,908472,129486,429614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]