SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341843 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341843 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199379,491901,786651,656030,81210,512033,552381,410454,910569,76478,449081,562629,400028,874494,31096,206160,445724,721777,491100,301298,378490,724691,536296,690180,340352,782667,160239,908443,694597,144267,178631,1041695,915687,418980,41362,318949,376451,1029918,590390,758156,74153,500491,866594,276761,47381,152661,578261,698951,627366,828289,261895,617052,861948,31867,261650,603776,122869,869222,666091,568070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]