SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991093 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991093 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883859,201056,195957,202639,546197,503271,959471,773843,510565,69862,807129,604760,30140,724656,949133,594809,853753,645755,128297,141238,1017210,182282,262719,70165,971012,175005,108111,190779,856131,910480,724242,966538,103470,79872,370087,617530,639559,424326,188899,1032012,51455,110595,569842,643328,901070,561888,621984,800358,596847,974594,494884,52118,305801,429492,4485,352475,487696,763322,470033,785965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]