SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528836 LIMIT 1 [ RunTime:0.000964s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528836 [ RunTime:0.003865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547535,687110,1032672,362596,903504,668936,402202,188177,574276,987570,602387,537554,783980,902960,940734,389444,942768,653530,155091,111430,231090,1041711,996925,863752,529200,992391,592772,376406,717324,322628,136482,770004,253218,940172,843212,685167,709163,250371,562952,424749,211766,443618,941748,252447,157937,586475,216797,1011711,674361,136163,422726,400803,788891,1000544,253112,83456,173481,101573,845971,932534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]