SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193111 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193111 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541457,115757,1037492,478365,43743,172105,197980,176960,608928,939821,1001208,121618,537357,762022,99912,640229,951694,350187,278224,363664,315309,722253,996502,508659,512069,724931,844246,705686,318668,253772,404000,304478,201922,128287,906880,1043978,843422,96327,178841,697247,325550,721280,817475,804373,11923,285620,528699,221581,803086,732670,523063,906393,150502,787132,622662,772541,569703,318961,450959,83801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]