SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31988 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31988 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264920,404734,666841,816224,735774,430456,30179,1001009,664924,861683,137193,219135,451830,290058,402771,484010,882350,1029193,43631,34777,1024180,520664,127986,162968,804493,431436,283313,584158,94525,551130,519029,183599,858611,365724,131140,349693,366595,44441,363957,561523,835183,305818,257435,790805,668045,725386,8030,380172,298230,933043,811478,168983,761304,207232,566170,194239,313071,883183,124897,645789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]