SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381583 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381583 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030693,152563,482765,327957,1045266,299914,518091,999660,866314,189159,692533,388617,599597,187736,926786,859710,639216,953938,808217,773607,731068,525235,489938,818303,77862,710619,381338,965323,88790,659302,925987,634417,234731,502305,310898,921876,105039,754924,877319,669478,910332,134884,189049,619573,597153,341484,794246,540779,821815,453952,817217,659681,532691,892385,416795,128560,1036982,353403,194824,663430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001172s ]