SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531967 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531967 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511842,122450,493406,764812,635716,1025690,349955,970492,821145,938814,378111,596827,600456,121051,387163,432335,983617,624590,949580,239035,246983,381872,932392,73237,886700,543613,564414,713733,19317,299096,875986,394179,194244,15360,990088,227044,517232,495823,17556,89940,459884,64897,375410,796495,809988,849450,841427,692792,769432,615161,515586,560593,1041718,554620,26684,53301,80814,446710,879221,700185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]