SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565313 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565313 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397990,864363,920964,134662,367764,819210,734162,57198,581192,720953,952607,753012,399604,592630,380189,279617,616042,38274,87630,976815,443847,359322,491840,378957,293899,574614,648038,163896,372060,277196,33001,727272,935957,788666,198225,516034,597697,197623,203825,777090,725917,349747,736404,1036793,382515,765036,510490,195961,76838,228731,484306,795885,575483,538706,472314,503691,186557,249265,276101,835321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]