SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983668 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983668 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431726,22164,372014,924786,643956,484533,848907,916050,467049,1022299,575452,411668,388438,544793,871282,420419,5201,557286,41452,336967,145856,37278,171583,1025690,71936,836469,848207,537105,314821,994071,68758,168898,853266,152042,185757,873724,995998,1018755,401336,390987,439479,196711,429153,1043653,367535,52129,774640,231734,417216,719671,926763,968563,481307,624090,807801,114468,609419,455629,809392,1018248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]