SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002973s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543496 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543496 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810174,339094,615208,320164,621321,615402,707788,450578,511380,1016446,140668,358727,7024,996151,516733,268386,72813,594655,422202,517052,638527,568260,12405,356853,832084,354090,675971,739558,500775,1031478,335182,641049,241580,602583,612504,257611,131601,1353,500153,745053,831814,439142,700710,708927,5458,575495,560840,410795,965848,811755,495295,97156,622356,483965,498315,311156,131226,618685,486528,995611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]