SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001769s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200841 LIMIT 1 [ RunTime:0.000652s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200841 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904788,887830,102146,540271,186928,550091,162706,829936,33097,417016,697294,782581,151091,342632,811467,1034796,433335,935607,374995,299042,64456,277009,1037301,837557,834395,786318,1006107,887147,438580,989069,311758,181562,185736,545374,674302,956254,82196,585798,1018455,750898,868633,702289,634760,484227,536747,1040234,208319,968798,679212,457064,695248,677563,767825,535287,145868,475549,884102,316418,459336,365045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]