SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32010 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32010 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690722,876266,747093,19526,367781,97165,341914,140239,471104,902480,808332,550308,655031,185680,982128,624633,491626,182265,867788,996145,762710,283538,792504,107238,422435,342563,839183,768149,632814,287094,83925,161580,557111,961147,149834,350068,811165,617047,311473,374553,558292,77166,764992,537802,760926,438043,199572,144613,346453,805046,329239,1020302,736913,842659,742970,136952,167311,973821,755840,1023722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]