SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802921 LIMIT 1 [ RunTime:0.001170s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802921 [ RunTime:0.002925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846945,27203,101253,344098,406891,457010,161104,193856,636824,635451,977970,237870,481427,269312,754176,632953,925352,510589,410787,283880,30571,697078,77655,436383,707093,685995,976812,663179,935585,112471,735493,469874,922315,902172,52639,192534,51727,645664,323080,509085,357609,213713,549871,519979,589391,393866,898948,1033768,466147,637620,952867,637384,607936,108527,264414,586306,188479,443961,119375,829182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000900s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004634s ]