SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106440 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106440 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025069,429344,18366,318762,364717,625718,1046854,338709,874394,714011,86951,193946,759913,1041812,844868,317665,426597,457058,86030,878409,621072,22103,469746,32995,246956,215594,245293,225202,18833,366467,201846,5745,521781,1021519,302453,493760,629142,685516,358754,572365,386244,521351,192632,410560,226004,491127,980977,1007508,1027013,428939,779133,171269,438131,226320,304025,262301,687725,15669,1005415,285233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]